Portfolio Report

Dataset statistics

Number of variables	69
Number of observations	424431
Missing cells	34652
Missing cells (%)	0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	223.4 MiB
Average record size in memory	552.0 B

Variable types

CAT	30
NUM	26
BOOL	11
UNSUPPORTED	2

Warnings

`EEA_PolicyYear` has constant value "424431"	Constant
`Vehicle_Make_Description` has a high cardinality: 7650 distinct values	High cardinality
`Driver_Total_Licensed_In_State` is highly correlated with `Driver_Total`	High correlation
`Driver_Total` is highly correlated with `Driver_Total_Licensed_In_State`	High correlation
`Driver_Maximum_Age` is highly correlated with `Driver_Minimum_Age`	High correlation
`Driver_Minimum_Age` is highly correlated with `Driver_Maximum_Age`	High correlation
`Severity` is highly correlated with `Loss_Amount`	High correlation
`Loss_Amount` is highly correlated with `Severity`	High correlation
`EEA_Prior_Bodily_Injury_Limit` is highly correlated with `Vehicle_Bodily_Injury_Limit`	High correlation
`Vehicle_Bodily_Injury_Limit` is highly correlated with `EEA_Prior_Bodily_Injury_Limit`	High correlation
`Vehicle_Bodily_Injury_Limit` has 17326 (4.1%) missing values	Missing
`EEA_Prior_Bodily_Injury_Limit` has 17326 (4.1%) missing values	Missing
`Vehicle_Days_Per_Week_Driven` is highly skewed (γ1 = -58.63345215)	Skewed
`Loss_Amount` is highly skewed (γ1 = 103.5190468)	Skewed
`Frequency` is highly skewed (γ1 = 143.6096443)	Skewed
`Severity` is highly skewed (γ1 = 108.4729269)	Skewed
`Loss_Ratio` is highly skewed (γ1 = 288.7197059)	Skewed
`PolicyNo` has unique values	Unique
`Policy_Zip_Code_Garaging_Location` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`EEA_Policy_Zip_Code_3` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Driver_Total_Married` has 165677 (39.0%) zeros	Zeros
`Driver_Total_Adult_Ages_50_64` has 301761 (71.1%) zeros	Zeros
`Vehicle_Driver_Points` has 381289 (89.8%) zeros	Zeros
`EEA_Policy_Tenure` has 41876 (9.9%) zeros	Zeros
`Claim_Count` has 405562 (95.6%) zeros	Zeros
`Loss_Amount` has 405562 (95.6%) zeros	Zeros
`Frequency` has 405562 (95.6%) zeros	Zeros
`Severity` has 405562 (95.6%) zeros	Zeros
`Loss_Ratio` has 405564 (95.6%) zeros	Zeros

Reproduction

Analysis started	2020-11-04 21:45:48.704708
Analysis finished	2020-11-04 21:55:26.630013
Duration	9 minutes and 37.93 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

PolicyNo
Real number (ℝ_≥0)

UNIQUE

Distinct	424431
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	314487432
Minimum	164532941
Maximum	382348800
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	164532941
5-th percentile	192994033.5
Q1	283244217
median	332617706
Q3	361279753
95-th percentile	376110250
Maximum	382348800
Range	217815859
Interquartile range (IQR)	78035536

Descriptive statistics

Standard deviation	57761418.75
Coefficient of variation (CV)	0.1836684486
Kurtosis	-0.1758964826
Mean	314487432
Median Absolute Deviation (MAD)	33871796
Skewness	-0.9510756048
Sum	1.334782153e+14
Variance	3.336381496e+15
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
379592700	1	< 0.1%
331222808	1	< 0.1%
365191202	1	< 0.1%
350500905	1	< 0.1%
373434400	1	< 0.1%
361876902	1	< 0.1%
242487340	1	< 0.1%
340064305	1	< 0.1%
357886003	1	< 0.1%
341293905	1	< 0.1%
Other values (424421)	424421	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
164532941	1	< 0.1%
164533241	1	< 0.1%
164534633	1	< 0.1%
164534839	1	< 0.1%
164534840	1	< 0.1%

Value	Count	Frequency (%)
382348800	1	< 0.1%
382162500	1	< 0.1%
382057400	1	< 0.1%
381735600	1	< 0.1%
381713000	1	< 0.1%

Policy_Company
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Standard	397788
Preferred	26643

Frequencies
Length

Value	Count	Frequency (%)
Standard	397788	93.7%
Preferred	26643	6.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Policy_Installment_Term
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

6	408536
12	15895

Frequencies
Length

Value	Count	Frequency (%)
6	408536	96.3%
12	15895	3.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	1
Mean length	1.037450139
Min length	1

Policy_Billing_Code
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Direct Billed to Insured	415344
Premium Finance	9087

Frequencies
Length

Value	Count	Frequency (%)
Direct Billed to Insured	415344	97.9%
Premium Finance	9087	2.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	24
Median length	24
Mean length	23.80731144
Min length	15

Policy_Method_Of_Payment
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Installment	213826
Pre-paid	210605

Frequencies
Length

Value	Count	Frequency (%)
Installment	213826	50.4%
Pre-paid	210605	49.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	11
Mean length	9.511383476
Min length	8

Policy_Reinstatement_Fee_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

N	374330
Y	50101

Common Values
Chart

Value	Count	Frequency (%)
N	374330	88.2%
Y	50101	11.8%

Policy_Zip_Code_Garaging_Location
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Vehicle_Territory
Real number (ℝ_≥0)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	31.05162912
Minimum	13
Maximum	37
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	13
5-th percentile	20
Q1	30
median	31
Q3	35
95-th percentile	35
Maximum	37
Range	24
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.186688377
Coefficient of variation (CV)	0.1348299106
Kurtosis	6.178835791
Mean	31.05162912
Median Absolute Deviation (MAD)	1
Skewness	-2.145050356
Sum	13179274
Variance	17.52835957
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
31	180388	42.5%
35	107854	25.4%
30	70212	16.5%
27	16609	3.9%
32	9381	2.2%
37	9041	2.1%
17	5335	1.3%
13	4836	1.1%
26	4346	1.0%
20	3415	0.8%
Other values (6)	13014	3.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13	4836	1.1%
15	1893	0.4%
16	2850	0.7%
17	5335	1.3%
18	1908	0.4%

Value	Count	Frequency (%)
37	9041	2.1%
36	3273	0.8%
35	107854	25.4%
32	9381	2.2%
31	180388	42.5%

Vehicle_Make_Year
Real number (ℝ_≥0)

Distinct	80
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1996.753482
Minimum	1924
Maximum	2008
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1924
5-th percentile	1984
Q1	1993
median	1998
Q3	2002
95-th percentile	2005
Maximum	2008
Range	84
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	7.388605208
Coefficient of variation (CV)	0.003700309165
Kurtosis	4.33133002
Mean	1996.753482
Median Absolute Deviation (MAD)	4
Skewness	-1.559986621
Sum	847484077
Variance	54.59148692
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	28768	6.8%
1999	27523	6.5%
2002	27243	6.4%
2001	26479	6.2%
2003	25933	6.1%
2004	25150	5.9%
1998	23959	5.6%
1997	23848	5.6%
2005	23240	5.5%
1995	22245	5.2%
Other values (70)	170043	40.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1924	2	< 0.1%
1927	1	< 0.1%
1928	6	< 0.1%
1929	4	< 0.1%
1930	6	< 0.1%

Value	Count	Frequency (%)
2008	32	< 0.1%
2007	3818	0.9%
2006	16979	4.0%
2005	23240	5.5%
2004	25150	5.9%

Vehicle_Make_Description
Categorical

HIGH CARDINALITY

Distinct	7650
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

FORD F150	15599
CHEV PICKUP1500	12165
FORD RANGER	10418
CHEV S10 PICKUP	7778
CHEV SILVER1500	7411
Other values (7645)	371060

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
FORD F150	15599	3.7%
CHEV PICKUP1500	12165	2.9%
FORD RANGER	10418	2.5%
CHEV S10 PICKUP	7778	1.8%
CHEV SILVER1500	7411	1.7%
TYTA CAMRY	6435	1.5%
DODG RAM PU1500	6277	1.5%
FORD EXPLORER	6036	1.4%
HOND ACCORD EX	5725	1.3%
HOND ACCORD LX	4845	1.1%
Other values (7640)	341742	80.5%

Frequencies of value counts

Unique

Unique	3133 ?
Unique (%)	0.7%

Histogram of lengths of the category

Length

Max length	19
Median length	17
Mean length	16.99991518
Min length	16

Vehicle_Performance
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Standard	404713
Intermediate	11381
High	5386
Sports Premium	1870
Sports	1081

Frequencies
Length

Value	Count	Frequency (%)
Standard	404713	95.4%
Intermediate	11381	2.7%
High	5386	1.3%
Sports Premium	1870	0.4%
Sports	1081	0.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	14
Median length	8
Mean length	8.077840686
Min length	4

Vehicle_New_Cost_Amount
Real number (ℝ)

Distinct	177
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	290.3339577
Minimum	-1
Maximum	99999
Zeros	662
Zeros (%)	0.2%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	-1
Q3	-1
95-th percentile	-1
Maximum	99999
Range	100000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2876.61906
Coefficient of variation (CV)	9.907966269
Kurtosis	308.1680916
Mean	290.3339577
Median Absolute Deviation (MAD)	0
Skewness	14.72918365
Sum	123226732
Variance	8274937.214
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	417345	98.3%
0	662	0.2%
20000	619	0.1%
18000	434	0.1%
15000	413	0.1%
25000	397	0.1%
12000	375	0.1%
10000	350	0.1%
16000	260	0.1%
14000	244	0.1%
Other values (167)	3332	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	417345	98.3%
0	662	0.2%
1	12	< 0.1%
2	17	< 0.1%
3	15	< 0.1%

Value	Count	Frequency (%)
99999	4	< 0.1%
98203	2	< 0.1%
98000	1	< 0.1%
96000	1	< 0.1%
95000	4	< 0.1%

Vehicle_Symbol
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.19234693
Minimum	-1
Maximum	27
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	5
Q1	8
median	11
Q3	14
95-th percentile	18
Maximum	27
Range	28
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.007122979
Coefficient of variation (CV)	0.3580234783
Kurtosis	-0.0262732829
Mean	11.19234693
Median Absolute Deviation (MAD)	3
Skewness	0.2008648345
Sum	4750379
Variance	16.05703457
Monotocity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
8	48122	11.3%
11	46364	10.9%
10	45188	10.6%
12	45133	10.6%
14	36734	8.7%
13	36180	8.5%
7	29851	7.0%
15	28355	6.7%
6	19994	4.7%
16	18643	4.4%
Other values (18)	69867	16.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	25	< 0.1%
1	681	0.2%
2	2071	0.5%
3	3889	0.9%
4	10099	2.4%

Value	Count	Frequency (%)
27	120	< 0.1%
26	203	< 0.1%
25	275	0.1%
24	616	0.1%
23	1110	0.3%

Vehicle_Number_Of_Drivers_Assigned
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	28.39731782
Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	99
95-th percentile	99
Maximum	99
Range	98
Interquartile range (IQR)	98

Descriptive statistics

Standard deviation	43.95258053
Coefficient of variation (CV)	1.547772251
Kurtosis	-1.032115783
Mean	28.39731782
Median Absolute Deviation (MAD)	0
Skewness	0.9837752691
Sum	12052702
Variance	1931.829335
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	295837	69.7%
99	118544	27.9%
2	9283	2.2%
3	666	0.2%
4	74	< 0.1%
5	18	< 0.1%
6	6	< 0.1%
8	2	< 0.1%
7	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	295837	69.7%
2	9283	2.2%
3	666	0.2%
4	74	< 0.1%
5	18	< 0.1%

Value	Count	Frequency (%)
99	118544	27.9%
8	2	< 0.1%
7	1	< 0.1%
6	6	< 0.1%
5	18	< 0.1%

Vehicle_Usage
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Pleasure	227389
Work	155103
Farm	39141
Business	2798

Frequencies
Length

Value	Count	Frequency (%)
Pleasure	227389	53.6%
Work	155103	36.5%
Farm	39141	9.2%
Business	2798	0.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Vehicle_Miles_To_Work
Real number (ℝ)

Distinct	80
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.302400155
Minimum	-1
Maximum	99
Zeros	1066
Zeros (%)	0.3%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	-1
Q3	6
95-th percentile	16
Maximum	99
Range	100
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	7.698294062
Coefficient of variation (CV)	2.331120913
Kurtosis	14.42742285
Mean	3.302400155
Median Absolute Deviation (MAD)	0
Skewness	3.000574705
Sum	1401641
Variance	59.26373146
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	266232	62.7%
10	30906	7.3%
5	18533	4.4%
12	12986	3.1%
8	11489	2.7%
6	9314	2.2%
3	8511	2.0%
14	8279	2.0%
4	7380	1.7%
2	7087	1.7%
Other values (70)	43714	10.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	266232	62.7%
0	1066	0.3%
1	4148	1.0%
2	7087	1.7%
3	8511	2.0%

Value	Count	Frequency (%)
99	65	< 0.1%
98	1	< 0.1%
95	2	< 0.1%
93	1	< 0.1%
90	7	< 0.1%

Vehicle_Days_Per_Week_Driven
Real number (ℝ)

SKEWED

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.998798391
Minimum	-1
Maximum	9
Zeros	63
Zeros (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	5
Q1	5
median	5
Q3	5
95-th percentile	5
Maximum	9
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0807188444
Coefficient of variation (CV)	0.01614764951
Kurtosis	3884.678026
Mean	4.998798391
Median Absolute Deviation (MAD)	0
Skewness	-58.63345215
Sum	2121645
Variance	0.006515531842
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
5	424278	> 99.9%
0	63	< 0.1%
-1	19	< 0.1%
1	17	< 0.1%
3	16	< 0.1%
6	15	< 0.1%
2	7	< 0.1%
7	5	< 0.1%
4	5	< 0.1%
8	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	19	< 0.1%
0	63	< 0.1%
1	17	< 0.1%
2	7	< 0.1%
3	16	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
8	4	< 0.1%
7	5	< 0.1%
6	15	< 0.1%
5	424278	> 99.9%

Vehicle_Annual_Miles
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Unknown	424341
0	74
500000	4
20000	3
30000	2
Other values (5)	7

Frequencies
Length

Value	Count	Frequency (%)
Unknown	424341	> 99.9%
0	74	< 0.1%
500000	4	< 0.1%
20000	3	< 0.1%
30000	2	< 0.1%
50000	2	< 0.1%
60000	2	< 0.1%
70000	1	< 0.1%
100000	1	< 0.1%
150000	1	< 0.1%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	7
Median length	7
Mean length	6.998892635
Min length	1

Vehicle_Anti_Theft_Device
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Not Applicable	248634
Passive Disabling-Vehicle Recovery	133362
Alarm Only	31852
Active Disabling	10578
Unknown	5

Frequencies
Length

Value	Count	Frequency (%)
Not Applicable	248634	58.6%
Passive Disabling-Vehicle Recovery	133362	31.4%
Alarm Only	31852	7.5%
Active Disabling	10578	2.5%
Unknown	5	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	34
Median length	14
Mean length	20.03385003
Min length	7

Vehicle_Passive_Restraint
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Y	311935
N	112415
Unknown	81

Frequencies
Length

Value	Count	Frequency (%)
Y	311935	73.5%
N	112415	26.5%
Unknown	81	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.001145062
Min length	1

Vehicle_Age_In_Years
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.03712971
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	9
Q3	9
95-th percentile	9
Maximum	9
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.57615158
Coefficient of variation (CV)	0.3660798772
Kurtosis	-0.4468997879
Mean	7.03712971
Median Absolute Deviation (MAD)	0
Skewness	-0.9887744872
Sum	2986776
Variance	6.636556966
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
9	225601	53.2%
8	28145	6.6%
7	28094	6.6%
5	27122	6.4%
6	26797	6.3%
4	25740	6.1%
3	24604	5.8%
2	23057	5.4%
1	15271	3.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15271	3.6%
2	23057	5.4%
3	24604	5.8%
4	25740	6.1%
5	27122	6.4%

Value	Count	Frequency (%)
9	225601	53.2%
8	28145	6.6%
7	28094	6.6%
6	26797	6.3%
5	27122	6.4%

Vehicle_Med_Pay_Limit
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2787.138772
Minimum	-1
Maximum	50000
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	1000
median	1000
Q3	5000
95-th percentile	10000
Maximum	50000
Range	50001
Interquartile range (IQR)	4000

Descriptive statistics

Standard deviation	6182.910179
Coefficient of variation (CV)	2.218371845
Kurtosis	41.00030559
Mean	2787.138772
Median Absolute Deviation (MAD)	1001
Skewness	6.002753412
Sum	1182948096
Variance	38228378.29
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1000	194993	45.9%
-1	98904	23.3%
5000	95446	22.5%
2000	13817	3.3%
10000	12059	2.8%
50000	5292	1.2%
25000	3920	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	98904	23.3%
1000	194993	45.9%
2000	13817	3.3%
5000	95446	22.5%
10000	12059	2.8%

Value	Count	Frequency (%)
50000	5292	1.2%
25000	3920	0.9%
10000	12059	2.8%
5000	95446	22.5%
2000	13817	3.3%

Vehicle_Bodily_Injury_Limit
Categorical

HIGH CORRELATION
MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	17326
Missing (%)	4.1%
Memory size	3.2 MiB

25-50	145145
100-300	130255
50-100	107950
250-500	21757
500-500	837
Other values (3)	1161

Frequencies
Length

Value	Count	Frequency (%)
25-50	145145	34.2%
100-300	130255	30.7%
50-100	107950	25.4%
250-500	21757	5.1%
500-500	837	0.2%
300-500	617	0.1%
100-500	502	0.1%
1M-1M	42	< 0.1%
(Missing)	17326	4.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	7
Mean length	6.836713152
Min length	3

Vehicle_Physical_Damage_Limit
Real number (ℝ)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	48008.89346
Minimum	-1
Maximum	1000000
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	25000
Q1	25000
median	50000
Q3	50000
95-th percentile	100000
Maximum	1000000
Range	1000001
Interquartile range (IQR)	25000

Descriptive statistics

Standard deviation	37280.72648
Coefficient of variation (CV)	0.7765379243
Kurtosis	62.80490013
Mean	48008.89346
Median Absolute Deviation (MAD)	25000
Skewness	5.255850276
Sum	2.037646266e+10
Variance	1389852567
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
50000	167950	39.6%
25000	146600	34.5%
100000	61109	14.4%
35000	27138	6.4%
-1	17338	4.1%
250000	3629	0.9%
500000	642	0.2%
1000000	25	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	17338	4.1%
25000	146600	34.5%
35000	27138	6.4%
50000	167950	39.6%
100000	61109	14.4%

Value	Count	Frequency (%)
1000000	25	< 0.1%
500000	642	0.2%
250000	3629	0.9%
100000	61109	14.4%
50000	167950	39.6%

Vehicle_Comprehensive_Coverage_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

N	407486
Y	16945

Common Values
Chart

Value	Count	Frequency (%)
N	407486	96.0%
Y	16945	4.0%

Vehicle_Comprehensive_Coverage_Limit
Real number (ℝ)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5939.581496
Minimum	-1
Maximum	1000000
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	-1
Q3	-1
95-th percentile	-1
Maximum	1000000
Range	1000001
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	39558.29284
Coefficient of variation (CV)	6.660114499
Kurtosis	129.1706939
Mean	5939.581496
Median Absolute Deviation (MAD)	0
Skewness	10.1791575
Sum	2520942514
Variance	1564858532
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
-1	407486	96.0%
75000	8026	1.9%
100000	5179	1.2%
300000	2037	0.5%
500000	1386	0.3%
200000	272	0.1%
1000000	37	< 0.1%
750000	8	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	407486	96.0%
75000	8026	1.9%
100000	5179	1.2%
200000	272	0.1%
300000	2037	0.5%

Value	Count	Frequency (%)
1000000	37	< 0.1%
750000	8	< 0.1%
500000	1386	0.3%
300000	2037	0.5%
200000	272	0.1%

Vehicle_Collision_Coverage_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Y	258725
N	165706

Common Values
Chart

Value	Count	Frequency (%)
Y	258725	61.0%
N	165706	39.0%

Vehicle_Collision_Coverage_Deductible
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	295.7718546
Minimum	-1
Maximum	3000
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	250
Q3	500
95-th percentile	500
Maximum	3000
Range	3001
Interquartile range (IQR)	501

Descriptive statistics

Standard deviation	277.2630639
Coefficient of variation (CV)	0.9374220691
Kurtosis	2.652845744
Mean	295.7718546
Median Absolute Deviation (MAD)	250
Skewness	0.7289422631
Sum	125534744
Variance	76874.80659
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
500	193364	45.6%
-1	165706	39.0%
250	44714	10.5%
1000	16607	3.9%
100	2664	0.6%
200	842	0.2%
2000	205	< 0.1%
50	203	< 0.1%
3000	126	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	165706	39.0%
50	203	< 0.1%
100	2664	0.6%
200	842	0.2%
250	44714	10.5%

Value	Count	Frequency (%)
3000	126	< 0.1%
2000	205	< 0.1%
1000	16607	3.9%
500	193364	45.6%
250	44714	10.5%

Driver_Total
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

1	374495
2	49898
3	34
4	4

Frequencies
Length

Value	Count	Frequency (%)
1	374495	88.2%
2	49898	11.8%
3	34	< 0.1%
4	4	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Male
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

1	222967
0	198925
2	2537
3	2

Frequencies
Length

Value	Count	Frequency (%)
1	222967	52.5%
0	198925	46.9%
2	2537	0.6%
3	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Female
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

1	238676
0	181914
2	3837
3	4

Frequencies
Length

Value	Count	Frequency (%)
1	238676	56.2%
0	181914	42.9%
2	3837	0.9%
3	4	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Single
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	324055
1	98170
2	2201
3	5

Frequencies
Length

Value	Count	Frequency (%)
0	324055	76.4%
1	98170	23.1%
2	2201	0.5%
3	5	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Married
Real number (ℝ_≥0)

ZEROS

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.6974019334
Minimum	0
Maximum	4
Zeros	165677
Zeros (%)	39.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	2
Maximum	4
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.6217794059
Coefficient of variation (CV)	0.8915653602
Kurtosis	-0.6553071907
Mean	0.6974019334
Median Absolute Deviation (MAD)	0
Skewness	0.3175130168
Sum	295999
Variance	0.3866096296
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
1	221521	52.2%
0	165677	39.0%
2	37224	8.8%
3	6	< 0.1%
4	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	165677	39.0%
1	221521	52.2%
2	37224	8.8%
3	6	< 0.1%
4	3	< 0.1%

Value	Count	Frequency (%)
4	3	< 0.1%
3	6	< 0.1%
2	37224	8.8%
1	221521	52.2%
0	165677	39.0%

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

1	326155
0	97997
2	279

Frequencies
Length

Value	Count	Frequency (%)
1	326155	76.8%
0	97997	23.1%
2	279	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	317634
1	106624
2	173

Frequencies
Length

Value	Count	Frequency (%)
0	317634	74.8%
1	106624	25.1%
2	173	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	392893
1	31314
2	223
3	1

Frequencies
Length

Value	Count	Frequency (%)
0	392893	92.6%
1	31314	7.4%
2	223	0.1%
3	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Licensed_In_State
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.113450714
Minimum	0
Maximum	4
Zeros	1468
Zeros (%)	0.3%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	4
Range	4
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3281983557
Coefficient of variation (CV)	0.2947578654
Kurtosis	3.829329408
Mean	1.113450714
Median Absolute Deviation (MAD)	0
Skewness	2.150883335
Sum	472583
Variance	0.1077141607
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
1	373385	88.0%
2	49540	11.7%
0	1468	0.3%
3	34	< 0.1%
4	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1468	0.3%
1	373385	88.0%
2	49540	11.7%
3	34	< 0.1%
4	4	< 0.1%

Value	Count	Frequency (%)
4	4	< 0.1%
3	34	< 0.1%
2	49540	11.7%
1	373385	88.0%
0	1468	0.3%

Driver_Minimum_Age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	86
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.225443
Minimum	0
Maximum	99
Zeros	1
Zeros (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	34
median	46
Q3	57
95-th percentile	74
Maximum	99
Range	99
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	15.9579441
Coefficient of variation (CV)	0.3452199278
Kurtosis	-0.5122435381
Mean	46.225443
Median Absolute Deviation (MAD)	11
Skewness	0.2161092671
Sum	19619511
Variance	254.6559798
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	10306	2.4%
43	10152	2.4%
46	10147	2.4%
45	10101	2.4%
41	10011	2.4%
44	9923	2.3%
49	9922	2.3%
48	9874	2.3%
47	9683	2.3%
50	9650	2.3%
Other values (76)	324662	76.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
15	2	< 0.1%
16	3430	0.8%
17	4224	1.0%
18	4665	1.1%

Value	Count	Frequency (%)
99	14	< 0.1%
98	7	< 0.1%
97	13	< 0.1%
96	28	< 0.1%
95	22	< 0.1%

Driver_Maximum_Age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	86
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	47.26590895
Minimum	0
Maximum	99
Zeros	1
Zeros (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	22
Q1	36
median	47
Q3	58
95-th percentile	75
Maximum	99
Range	99
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	15.66376222
Coefficient of variation (CV)	0.3313966149
Kurtosis	-0.4630305637
Mean	47.26590895
Median Absolute Deviation (MAD)	11
Skewness	0.2087235089
Sum	20061117
Variance	245.353447
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46	10603	2.5%
43	10551	2.5%
42	10546	2.5%
45	10526	2.5%
49	10416	2.5%
41	10347	2.4%
48	10328	2.4%
44	10319	2.4%
47	10070	2.4%
50	10056	2.4%
Other values (76)	320669	75.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
15	1	< 0.1%
16	2260	0.5%
17	3000	0.7%
18	3451	0.8%

Value	Count	Frequency (%)
99	16	< 0.1%
98	10	< 0.1%
97	13	< 0.1%
96	30	< 0.1%
95	23	< 0.1%

Driver_Total_Teenager_Age_15_19
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	407343
1	16957
2	131

Frequencies
Length

Value	Count	Frequency (%)
0	407343	96.0%
1	16957	4.0%
2	131	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_College_Ages_20_23
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	405549
1	18399
2	483

Frequencies
Length

Value	Count	Frequency (%)
0	405549	95.6%
1	18399	4.3%
2	483	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Young_Adult_Ages_24_29
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	389360
1	33055
2	2016

Frequencies
Length

Value	Count	Frequency (%)
0	389360	91.7%
1	33055	7.8%
2	2016	0.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Low_Middle_Adult_Ages_30_39
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	339962
1	78941
2	5527
3	1

Frequencies
Length

Value	Count	Frequency (%)
0	339962	80.1%
1	78941	18.6%
2	5527	1.3%
3	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Middle_Adult_Ages_40_49
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	317015
1	101906
2	5509
3	1

Frequencies
Length

Value	Count	Frequency (%)
0	317015	74.7%
1	101906	24.0%
2	5509	1.3%
3	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Adult_Ages_50_64
Real number (ℝ_≥0)

ZEROS

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3081655204
Minimum	0
Maximum	4
Zeros	301761
Zeros (%)	71.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	4
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.501503267
Coefficient of variation (CV)	1.627382798
Kurtosis	0.5656378634
Mean	0.3081655204
Median Absolute Deviation (MAD)	0
Skewness	1.279408391
Sum	130795
Variance	0.2515055268
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
0	301761	71.1%
1	114548	27.0%
2	8120	1.9%
4	1	< 0.1%
3	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	301761	71.1%
1	114548	27.0%
2	8120	1.9%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
4	1	< 0.1%
3	1	< 0.1%
2	8120	1.9%
1	114548	27.0%
0	301761	71.1%

Driver_Total_Senior_Ages_65_69
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	399279
1	24225
2	927

Frequencies
Length

Value	Count	Frequency (%)
0	399279	94.1%
1	24225	5.7%
2	927	0.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Driver_Total_Upper_Senior_Ages_70_plus
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

0	385964
1	35996
2	2471

Frequencies
Length

Value	Count	Frequency (%)
0	385964	90.9%
1	35996	8.5%
2	2471	0.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Vehicle_Youthful_Driver_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

N	383191
Y	41240

Common Values
Chart

Value	Count	Frequency (%)
N	383191	90.3%
Y	41240	9.7%

Vehicle_Youthful_Driver_Training_Code
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Not Applicable	383191
With or Without Driver Training	20305
Without Driver Training	17635
With Driver Training	3300

Frequencies
Length

Value	Count	Frequency (%)
Not Applicable	383191	90.3%
With or Without Driver Training	20305	4.8%
Without Driver Training	17635	4.2%
With Driver Training	3300	0.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	31
Median length	31
Mean length	31
Min length	31

Vehicle_Youthful_Good_Student_Code
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Not Eligible for Good Student Credit	418562
Eligible for Good Student Credit	5869

Frequencies
Length

Value	Count	Frequency (%)
Not Eligible for Good Student Credit	418562	98.6%
Eligible for Good Student Credit	5869	1.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Vehicle_Driver_Points
Real number (ℝ_≥0)

ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1197650501
Minimum	0
Maximum	7
Zeros	381289
Zeros (%)	89.8%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3838138993
Coefficient of variation (CV)	3.204723739
Kurtosis	17.48905802
Mean	0.1197650501
Median Absolute Deviation (MAD)	0
Skewness	3.744983882
Sum	50832
Variance	0.1473131093
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	381289	89.8%
1	36431	8.6%
2	5905	1.4%
3	670	0.2%
4	108	< 0.1%
5	21	< 0.1%
6	5	< 0.1%
7	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	381289	89.8%
1	36431	8.6%
2	5905	1.4%
3	670	0.2%
4	108	< 0.1%

Value	Count	Frequency (%)
7	2	< 0.1%
6	5	< 0.1%
5	21	< 0.1%
4	108	< 0.1%
3	670	0.2%

Vehicle_Safe_Driver_Discount_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Y	255658
N	168773

Common Values
Chart

Value	Count	Frequency (%)
Y	255658	60.2%
N	168773	39.8%

EEA_Liability_Coverage_Only_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

N	306084
Y	118347

Common Values
Chart

Value	Count	Frequency (%)
N	306084	72.1%
Y	118347	27.9%

EEA_Multi_Auto_Policies_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Y	374855
N	49576

Common Values
Chart

Value	Count	Frequency (%)
Y	374855	88.3%
N	49576	11.7%

EEA_Policy_Zip_Code_3
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

EEA_Policy_Tenure
Real number (ℝ)

ZEROS

Distinct	463
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.886340772
Minimum	-1
Maximum	54
Zeros	41876
Zeros (%)	9.9%
Memory size	3.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	1.2
median	3.5
Q3	8.3
95-th percentile	19.8
Maximum	54
Range	55
Interquartile range (IQR)	7.1

Descriptive statistics

Standard deviation	6.646431763
Coefficient of variation (CV)	1.129127929
Kurtosis	4.850752332
Mean	5.886340772
Median Absolute Deviation (MAD)	3
Skewness	1.970534277
Sum	2498345.5
Variance	44.17505518
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	41876	9.9%
0.5	29084	6.9%
1	27607	6.5%
2	21991	5.2%
1.5	21816	5.1%
2.5	18426	4.3%
3	17414	4.1%
3.5	14086	3.3%
4	12520	2.9%
4.5	10407	2.5%
Other values (453)	209204	49.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	41	< 0.1%
0	41876	9.9%
0.1	111	< 0.1%
0.2	315	0.1%
0.3	1095	0.3%

Value	Count	Frequency (%)
54	1	< 0.1%
53.5	1	< 0.1%
47.9	1	< 0.1%
47.7	4	< 0.1%
47.6	4	< 0.1%

EEA_Agency_Type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Hybrid	122522
Preferred	109248
Standard	103007
Non-standard	89654

Frequencies
Length

Value	Count	Frequency (%)
Hybrid	122522	28.9%
Preferred	109248	25.7%
Standard	103007	24.3%
Non-standard	89654	21.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	12
Median length	8
Mean length	8.524985216
Min length	6

EEA_Packaged_Policy_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

N	224758
Y	199673

Common Values
Chart

Value	Count	Frequency (%)
N	224758	53.0%
Y	199673	47.0%

EEA_Full_Coverage_Indicator
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Y	260490
N	163941

Common Values
Chart

Value	Count	Frequency (%)
Y	260490	61.4%
N	163941	38.6%

EEA_Prior_Bodily_Injury_Limit
Categorical

HIGH CORRELATION
MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	17326
Missing (%)	4.1%
Memory size	3.2 MiB

20-50	145145
100-200	130255
40-100	107950
100-400	21757
300-300	837
Other values (3)	1161

Frequencies
Length

Value	Count	Frequency (%)
20-50	145145	34.2%
100-200	130255	30.7%
40-100	107950	25.4%
100-400	21757	5.1%
300-300	837	0.2%
200-400	617	0.1%
75-300	502	0.1%
750-750	42	< 0.1%
(Missing)	17326	4.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	7
Mean length	6.151579409
Min length	3

EEA_PolicyYear
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

2006	424431

Frequencies
Length

Value	Count	Frequency (%)
2006	424431	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	4
Mean length	4
Min length	4

SYS_Renewed
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Y	376208
N	48223

Common Values
Chart

Value	Count	Frequency (%)
Y	376208	88.6%
N	48223	11.4%

SYS_New_Business
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

N	381786
Y	42645

Common Values
Chart

Value	Count	Frequency (%)
N	381786	90.0%
Y	42645	10.0%

Annual_Premium
Real number (ℝ_≥0)

Distinct	24777
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	335.3542278
Minimum	0.54
Maximum	3941.08
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0.54
5-th percentile	107.06
Q1	157.94
median	328.58
Q3	445.2
95-th percentile	666.74
Maximum	3941.08
Range	3940.54
Interquartile range (IQR)	287.26

Descriptive statistics

Standard deviation	206.2913852
Coefficient of variation (CV)	0.615144728
Kurtosis	10.04070716
Mean	335.3542278
Median Absolute Deviation (MAD)	147.32
Skewness	1.86363903
Sum	142334730.2
Variance	42556.13562
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120.84	3687	0.9%
124.02	2542	0.6%
133.56	2437	0.6%
135.68	2363	0.6%
130.38	2343	0.6%
137.8	2286	0.5%
125.08	2268	0.5%
129.32	2060	0.5%
138.86	2057	0.5%
132.5	2002	0.5%
Other values (24767)	400386	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.54	1	< 0.1%
0.56	1	< 0.1%
0.58	3	< 0.1%
0.6	1	< 0.1%
0.61	2	< 0.1%

Value	Count	Frequency (%)
3941.08	1	< 0.1%
3710	1	< 0.1%
3591.28	1	< 0.1%
3538.28	1	< 0.1%
3535.1	1	< 0.1%

Claim_Count
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.04689337018
Minimum	0
Maximum	5
Zeros	405562
Zeros (%)	95.6%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2235972157
Coefficient of variation (CV)	4.768205288
Kurtosis	30.01077819
Mean	0.04689337018
Median Absolute Deviation (MAD)	0
Skewness	5.113148748
Sum	19903
Variance	0.04999571485
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	405562	95.6%
1	17912	4.2%
2	893	0.2%
3	52	< 0.1%
4	11	< 0.1%
5	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405562	95.6%
1	17912	4.2%
2	893	0.2%
3	52	< 0.1%
4	11	< 0.1%

Value	Count	Frequency (%)
5	1	< 0.1%
4	11	< 0.1%
3	52	< 0.1%
2	893	0.2%
1	17912	4.2%

Loss_Amount
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	15891
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	235.4292386
Minimum	0
Maximum	1072291.86
Zeros	405562
Zeros (%)	95.6%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1072291.86
Range	1072291.86
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3399.225402
Coefficient of variation (CV)	14.43841649
Kurtosis	25330.3197
Mean	235.4292386
Median Absolute Deviation (MAD)	0
Skewness	103.5190468
Sum	99923467.17
Variance	11554733.33
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	405562	95.6%
54.5	1463	0.3%
1090	260	0.1%
49.05	212	< 0.1%
43.6	102	< 0.1%
109	101	< 0.1%
38.15	74	< 0.1%
2180	55	< 0.1%
5450	49	< 0.1%
27.25	49	< 0.1%
Other values (15881)	16504	3.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405562	95.6%
0.1	1	< 0.1%
0.11	1	< 0.1%
4.46	1	< 0.1%
6.49	1	< 0.1%

Value	Count	Frequency (%)
1072291.86	1	< 0.1%
445481.09	1	< 0.1%
327000	1	< 0.1%
299750	1	< 0.1%
297025	1	< 0.1%

Frequency
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	781
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1150178582
Minimum	0
Maximum	370.3703704
Zeros	405562
Zeros (%)	95.6%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	370.3703704
Range	370.3703704
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.636176241
Coefficient of variation (CV)	14.22541044
Kurtosis	27634.88023
Mean	0.1150178582
Median Absolute Deviation (MAD)	0
Skewness	143.6096443
Sum	48817.14456
Variance	2.677072691
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	405562	95.6%
2	15167	3.6%
1	1014	0.2%
4	729	0.2%
4.135649297	91	< 0.1%
4.066693778	88	< 0.1%
6	39	< 0.1%
4.111842105	37	< 0.1%
4.022526146	30	< 0.1%
4.08997955	29	< 0.1%
Other values (771)	1645	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405562	95.6%
1	1014	0.2%
1.00270731	4	< 0.1%
1.005530417	3	< 0.1%
1.008267796	3	< 0.1%

Value	Count	Frequency (%)
370.3703704	3	< 0.1%
357.1428571	1	< 0.1%
185.1851852	5	< 0.1%
181.8181818	4	< 0.1%
121.9512195	2	< 0.1%

Severity
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	15896
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	226.7193418
Minimum	0
Maximum	1072291.86
Zeros	405562
Zeros (%)	95.6%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1072291.86
Range	1072291.86
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3337.804293
Coefficient of variation (CV)	14.72218588
Kurtosis	27222.21876
Mean	226.7193418
Median Absolute Deviation (MAD)	0
Skewness	108.4729269
Sum	96226716.98
Variance	11140937.5
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	405562	95.6%
54.5	1569	0.4%
1090	260	0.1%
49.05	224	0.1%
43.6	108	< 0.1%
38.15	78	< 0.1%
2180	55	< 0.1%
27.25	50	< 0.1%
5450	49	< 0.1%
51.775	25	< 0.1%
Other values (15886)	16451	3.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405562	95.6%
0.1	1	< 0.1%
0.11	1	< 0.1%
4.46	1	< 0.1%
6.49	1	< 0.1%

Value	Count	Frequency (%)
1072291.86	1	< 0.1%
445481.09	1	< 0.1%
327000	1	< 0.1%
299750	1	< 0.1%
297025	1	< 0.1%

Loss_Ratio
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	4417
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.154622589
Minimum	0
Maximum	24787.14
Zeros	405564
Zeros (%)	95.6%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	24787.14
Range	24787.14
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	55.15386795
Coefficient of variation (CV)	47.76787539
Kurtosis	112442.5218
Mean	1.154622589
Median Absolute Deviation (MAD)	0
Skewness	288.7197059
Sum	490057.62
Variance	3041.949149
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	405564	95.6%
0.12	191	< 0.1%
0.13	168	< 0.1%
0.14	148	< 0.1%
0.11	140	< 0.1%
0.15	128	< 0.1%
0.16	110	< 0.1%
0.09	104	< 0.1%
0.1	94	< 0.1%
0.17	88	< 0.1%
Other values (4407)	17696	4.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405564	95.6%
0.01	2	< 0.1%
0.02	3	< 0.1%
0.03	6	< 0.1%
0.04	22	< 0.1%

Value	Count	Frequency (%)
24787.14	1	< 0.1%
15229.18	1	< 0.1%
8443.02	1	< 0.1%
6409.68	1	< 0.1%
5649.71	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	PolicyNo	Policy_Company	Policy_Installment_Term	Policy_Billing_Code	Policy_Method_Of_Payment	Policy_Reinstatement_Fee_Indicator	Policy_Zip_Code_Garaging_Location	Vehicle_Territory	Vehicle_Make_Year	Vehicle_Make_Description	Vehicle_Performance	Vehicle_New_Cost_Amount	Vehicle_Symbol	Vehicle_Number_Of_Drivers_Assigned	Vehicle_Usage	Vehicle_Miles_To_Work	Vehicle_Days_Per_Week_Driven	Vehicle_Annual_Miles	Vehicle_Anti_Theft_Device	Vehicle_Passive_Restraint	Vehicle_Age_In_Years	Vehicle_Med_Pay_Limit	Vehicle_Bodily_Injury_Limit	Vehicle_Physical_Damage_Limit	Vehicle_Comprehensive_Coverage_Indicator	Vehicle_Comprehensive_Coverage_Limit	Vehicle_Collision_Coverage_Indicator	Vehicle_Collision_Coverage_Deductible	Driver_Total	Driver_Total_Male	Driver_Total_Female	Driver_Total_Married	Driver_Total_Related_To_Insured_Self	Driver_Total_Related_To_Insured_Spouse	Driver_Total_Licensed_In_State	Driver_Minimum_Age	Driver_Maximum_Age	Driver_Total_Middle_Adult_Ages_40_49	Driver_Total_Adult_Ages_50_64	Driver_Total_Upper_Senior_Ages_70_plus	Vehicle_Youthful_Driver_Indicator	Vehicle_Youthful_Driver_Training_Code	Vehicle_Youthful_Good_Student_Code	Vehicle_Driver_Points	Vehicle_Safe_Driver_Discount_Indicator	EEA_Liability_Coverage_Only_Indicator	EEA_Multi_Auto_Policies_Indicator	EEA_Policy_Zip_Code_3	EEA_Policy_Tenure	EEA_Agency_Type	EEA_Packaged_Policy_Indicator	EEA_Full_Coverage_Indicator	EEA_Prior_Bodily_Injury_Limit	EEA_PolicyYear	SYS_Renewed	SYS_New_Business	Annual_Premium
0	164532941	Standard	6	Direct Billed to Insured	Pre-paid	N	43046	35	2004	BUIK LESABRE LI	Standard	-1	11	1	Farm	-1	5	Unknown	Not Applicable	Y	3	1000	250-500	100000	N	-1	Y	500	1	0	1	0	1	0	1	75	75	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	N	430	22.7	Standard	N	Y	100-400	2006	Y	N	320.12
1	164533241	Standard	6	Direct Billed to Insured	Pre-paid	N	Unknown	35	1980	CADILLAC 4-DOOR	Standard	-1	11	1	Farm	-1	5	Unknown	Not Applicable	N	9	2000	100-300	50000	N	-1	Y	50	1	0	1	1	0	0	1	71	71	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	N	Unknown	47.1	Preferred	N	Y	100-200	2006	Y	N	259.70
2	164534633	Standard	6	Direct Billed to Insured	Pre-paid	N	43555	17	2005	PONT MONTANA SV	Standard	-1	10	1	Pleasure	-1	5	Unknown	Passive Disabling-Vehicle Recovery	Y	2	50000	250-500	100000	N	-1	Y	100	1	1	0	1	1	0	1	80	80	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	N	435	47.2	Non-standard	N	Y	100-400	2006	Y	N	613.74
3	164534839	Standard	6	Direct Billed to Insured	Pre-paid	N	43561	17	2005	MERC GRAND MARQ	Standard	-1	12	1	Pleasure	-1	5	Unknown	Passive Disabling-Vehicle Recovery	Y	2	5000	50-100	35000	N	-1	Y	250	1	1	0	1	1	0	1	74	74	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	Y	435	46.7	Non-standard	Y	Y	40-100	2006	Y	N	541.66
4	164534840	Standard	6	Direct Billed to Insured	Pre-paid	N	43561	17	2005	MERC GRAND MARQ	Standard	-1	12	1	Pleasure	-1	5	Unknown	Passive Disabling-Vehicle Recovery	Y	2	5000	50-100	35000	N	-1	Y	250	1	1	0	1	1	0	1	75	75	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	Y	435	47.2	Non-standard	Y	Y	40-100	2006	Y	N	541.66
5	164534933	Standard	6	Direct Billed to Insured	Pre-paid	N	43052	27	1985	GMC S15	Standard	-1	7	1	Work	10	5	Unknown	Not Applicable	N	9	5000	25-50	25000	N	-1	N	-1	1	0	1	1	1	0	1	47	47	1	0	0	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	Y	430	16.5	Hybrid	Y	N	20-50	2006	Y	N	164.30
6	164542135	Standard	6	Direct Billed to Insured	Installment	N	44095	31	2002	FORD EXPLOR XLT	Standard	-1	11	1	Pleasure	-1	5	Unknown	Not Applicable	Y	5	1000	NaN	-1	Y	75000	Y	500	2	1	1	2	1	1	2	54	60	0	2	0	N	Not Applicable	Not Eligible for Good Student Credit	1	N	N	Y	440	16.5	Preferred	Y	Y	NaN	2006	Y	N	445.20
7	164542433	Standard	6	Direct Billed to Insured	Pre-paid	N	42858	35	2005	FORD F-150 SUPE	Standard	-1	16	1	Farm	-1	5	Unknown	Passive Disabling-Vehicle Recovery	Y	2	1000	250-500	100000	N	-1	Y	1000	2	1	1	2	1	1	2	74	85	0	0	2	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	Y	428	16.5	Standard	Y	Y	100-400	2006	Y	N	336.02
8	164543341	Standard	6	Direct Billed to Insured	Pre-paid	Y	42980	30	1991	CHEV S10 BLAZER	Standard	-1	12	1	Farm	-1	5	Unknown	Not Applicable	N	9	-1	50-100	50000	N	-1	N	-1	1	1	0	1	1	0	1	74	74	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	Y	Y	429	46.3	Non-standard	N	N	40-100	2006	Y	N	103.88
9	164544226	Standard	6	Direct Billed to Insured	Pre-paid	N	42597	30	2005	CADI DEVILLE	Intermediate	-1	15	1	Pleasure	-1	5	Unknown	Not Applicable	Y	2	1000	100-300	50000	N	-1	Y	500	1	1	0	0	1	0	1	71	71	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	Y	N	Y	425	16.5	Hybrid	Y	Y	100-200	2006	Y	N	505.62

Last rows

	PolicyNo	Policy_Company	Policy_Installment_Term	Policy_Billing_Code	Policy_Method_Of_Payment	Policy_Reinstatement_Fee_Indicator	Policy_Zip_Code_Garaging_Location	Vehicle_Territory	Vehicle_Make_Year	Vehicle_Make_Description	Vehicle_Performance	Vehicle_New_Cost_Amount	Vehicle_Symbol	Vehicle_Number_Of_Drivers_Assigned	Vehicle_Usage	Vehicle_Miles_To_Work	Vehicle_Days_Per_Week_Driven	Vehicle_Annual_Miles	Vehicle_Anti_Theft_Device	Vehicle_Passive_Restraint	Vehicle_Age_In_Years	Vehicle_Med_Pay_Limit	Vehicle_Bodily_Injury_Limit	Vehicle_Physical_Damage_Limit	Vehicle_Comprehensive_Coverage_Indicator	Vehicle_Comprehensive_Coverage_Limit	Vehicle_Collision_Coverage_Indicator	Vehicle_Collision_Coverage_Deductible	Driver_Total	Driver_Total_Male	Driver_Total_Female	Driver_Total_Single	Driver_Total_Married	Driver_Total_Related_To_Insured_Self	Driver_Total_Related_To_Insured_Child	Driver_Total_Licensed_In_State	Driver_Minimum_Age	Driver_Maximum_Age	Driver_Total_Teenager_Age_15_19	Driver_Total_College_Ages_20_23	Driver_Total_Young_Adult_Ages_24_29	Driver_Total_Low_Middle_Adult_Ages_30_39	Driver_Total_Middle_Adult_Ages_40_49	Driver_Total_Adult_Ages_50_64	Vehicle_Youthful_Driver_Indicator	Vehicle_Youthful_Driver_Training_Code	Vehicle_Youthful_Good_Student_Code	Vehicle_Driver_Points	Vehicle_Safe_Driver_Discount_Indicator	EEA_Liability_Coverage_Only_Indicator	EEA_Multi_Auto_Policies_Indicator	EEA_Policy_Zip_Code_3	EEA_Agency_Type	EEA_Packaged_Policy_Indicator	EEA_Full_Coverage_Indicator	EEA_Prior_Bodily_Injury_Limit	EEA_PolicyYear	SYS_Renewed	SYS_New_Business	Annual_Premium	Claim_Count	Loss_Amount	Frequency	Severity	Loss_Ratio
424421	381414400	Standard	6	Direct Billed to Insured	Pre-paid	N	42880	35	1977	GMC K1500 JIMMY	Standard	-1	10	99	Work	20	5	Unknown	Not Applicable	N	9	-1	NaN	-1	N	-1	N	-1	1	1	0	0	0	1	0	1	41	41	0	0	0	0	1	0	N	Not Applicable	Not Eligible for Good Student Credit	2	N	N	Y	428	Preferred	N	N	NaN	2006	N	Y	66.08	0	0.00	0.000000	0.00	0.00
424422	381444800	Standard	12	Premium Finance	Pre-paid	N	43438	26	2001	TYTA TUNDRA SR5	Standard	-1	15	99	Farm	-1	5	Unknown	Not Applicable	Y	7	5000	100-300	50000	N	-1	Y	500	1	1	0	0	1	1	0	1	29	29	0	0	1	0	0	0	N	Not Applicable	Not Eligible for Good Student Credit	0	N	N	Y	434	Hybrid	Y	Y	100-200	2006	Y	Y	751.54	0	0.00	0.000000	0.00	0.00
424423	381467800	Standard	12	Premium Finance	Pre-paid	N	42525	35	2004	MITS GALANT DE	Standard	-1	12	1	Pleasure	-1	5	Unknown	Passive Disabling-Vehicle Recovery	Y	4	1000	100-300	50000	N	-1	Y	500	1	0	1	1	0	1	0	1	22	22	0	1	0	0	0	0	Y	With or Without Driver Training	Not Eligible for Good Student Credit	1	N	N	N	425	Non-standard	N	Y	100-200	2006	N	Y	664.50	1	571.19	2.134472	571.19	0.86
424424	381471900	Standard	6	Direct Billed to Insured	Pre-paid	N	43427	31	2001	DODG STRATUS SE	Standard	-1	16	4	Work	3	5	Unknown	Not Applicable	Y	7	-1	25-50	25000	N	-1	Y	500	1	1	0	1	0	0	1	1	22	22	0	1	0	0	0	0	Y	With or Without Driver Training	Not Eligible for Good Student Credit	0	N	N	Y	434	Non-standard	Y	Y	20-50	2006	N	Y	649.55	0	0.00	0.000000	0.00	0.00
424425	381525500	Standard	12	Premium Finance	Pre-paid	N	42581	36	2007	NSSN VERSA S-VE	Standard	-1	7	99	Work	5	5	Unknown	Passive Disabling-Vehicle Recovery	Y	1	5000	100-300	100000	N	-1	Y	1000	1	1	0	0	1	1	0	1	35	35	0	0	0	1	0	0	N	Not Applicable	Not Eligible for Good Student Credit	0	N	N	Y	425	Non-standard	Y	Y	100-200	2006	Y	Y	541.26	0	0.00	0.000000	0.00	0.00
424426	381713000	Standard	6	Direct Billed to Insured	Pre-paid	N	42851	35	1999	PONT GR PRIX GT	Standard	-1	8	2	Pleasure	-1	5	Unknown	Passive Disabling-Vehicle Recovery	Y	9	5000	NaN	-1	Y	300000	N	-1	1	0	1	1	0	0	1	1	18	18	1	0	0	0	0	0	Y	Without Driver Training	Not Eligible for Good Student Credit	0	N	N	N	428	Preferred	N	Y	NaN	2006	Y	Y	162.55	0	0.00	0.000000	0.00	0.00
424427	381735600	Standard	6	Direct Billed to Insured	Pre-paid	N	43669	31	2000	NSSN QUEST	Standard	-1	8	2	Pleasure	-1	5	Unknown	Active Disabling	Y	8	5000	100-300	50000	N	-1	N	-1	1	0	1	1	0	0	1	1	20	20	0	1	0	0	0	0	Y	Without Driver Training	Not Eligible for Good Student Credit	0	N	N	Y	436	Hybrid	Y	N	100-200	2006	Y	Y	117.13	0	0.00	0.000000	0.00	0.00
424428	382057400	Standard	6	Direct Billed to Insured	Installment	N	42487	35	1997	PONT TRANSSPORT	Standard	-1	8	1	Pleasure	-1	5	Unknown	Passive Disabling-Vehicle Recovery	Y	9	50000	250-500	100000	N	-1	Y	500	1	1	0	0	1	1	0	1	58	58	0	0	0	0	0	1	N	Not Applicable	Not Eligible for Good Student Credit	0	N	N	Y	424	Preferred	N	Y	100-400	2006	N	Y	118.21	0	0.00	0.000000	0.00	0.00
424429	382162500	Preferred	6	Direct Billed to Insured	Installment	N	43360	31	1998	PONT SUNFIRE SE	Standard	-1	17	1	Pleasure	-1	5	Unknown	Not Applicable	Y	9	5000	50-100	50000	N	-1	N	-1	1	0	1	0	0	1	0	1	30	30	0	0	0	1	0	0	N	Not Applicable	Not Eligible for Good Student Credit	0	N	Y	Y	433	Non-standard	N	N	40-100	2006	N	Y	103.93	0	0.00	0.000000	0.00	0.00
424430	382348800	Standard	6	Direct Billed to Insured	Installment	N	43905	31	2006	CHEV TRAILBLAZE	Standard	-1	12	1	Work	12	5	Unknown	Passive Disabling-Vehicle Recovery	Y	2	-1	NaN	-1	N	-1	N	-1	1	0	1	0	1	1	0	1	44	44	0	0	0	0	1	0	N	Not Applicable	Not Eligible for Good Student Credit	0	N	N	Y	439	Non-standard	Y	N	NaN	2006	Y	Y	281.24	0	0.00	0.000000	0.00	0.00

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows